use OnlineInsurancePortal
go

--select * from Customer
	
insert into Customer values('Thanh','Nam','060968888','nam','1','Developer','01/10/1993','Hanoi','0973689193','vuthanhnam.it@gmail.com')
insert into Customer values('Le','Son','0608289431','son','1','Developer','03/10/1993','Nam Dinh','098877665','namtom101@gmail.com')

--select * from Employee

insert into Employee values('Vu','Thanh', 'admin', '1', '10/1/1993', 'Hanoi', '0973689193','nam@fpt.com', 1)
insert into Employee values('Vuong','Tung', 'tung', '1', '10/1/1993', 'Hanoi', '0973689193','tung@fpt.com', 0)

--select * from InsuranceType
insert into InsuranceType values('Compulsory Insurance','This is Compulsory insurance with the car owner according to the Financial, effective:<br/>
To compensate for loss of life, bodily and property for 3rd party caused by cars caused<br/>
To compensate for physical damage and life of passengers under a contract of carriage of passengers by cars caused<br/>
1. The responsibility insurance<br/>
Liability levels for assets damage by car owner:','30')

insert into InsuranceType values('Dammage Insurance','Objects insurance:<br/>
As the car physical damage caused by unexpected accidents beyond the control of the owner of the particular case insurance by rules prescribed.
Insurance scope<br/>
+ We compensation to vehicle owners the material damage caused by cars:<br/>
- The unexpected accidents, beyond the control of the owner, driving in these cases: Collision, flip, drop, falling, sinking, fire, fire, explosion, falling with other objects, and touch;<br/>
- The unforeseen disasters by nature: storms, floods, landslides, lightning, earthquakes, hail, tsunami;<br/>
- Stolen, lost all cars robbery. <br/>
+ In addition, We also Make the payment and necessary expenses reasonably incurred by accident coverage in order to prevent and limit incurring losses, and protect damage to the car repair place near best, damage assessment.<br/><br/>
Insurance benefits<br/>
Principles of compensation vehicle is restored back to its original state at the time when the loss occurs. <br/><br/>

To compensate for partial loss : We are responsible for the actual cost to repair or replace (if not repaired) parts lost <br/>
+ Where the insured vehicle with the insured amount less than the actual value, the amount of compensation on Vietnam are prorated between the insured amount and the actual value of the cars. <br/>
+ In case of cars covered by or on the actual value of compensation on Vietnam by the actual value of that part right before cars accident. <br/><br/>

To compensate for the entire loss: Vehicles are considered total loss in following cases: <br/>
+ Vehicle damaged to the extent of 75% or beyond repair, restore circulation to ensure safety, rehabilitation or cost equal to or greater than the actual value of the cars. <br/>
+ Vehicle is stolen, robbed (the conclusion of the authorities). <br/>
Entire compensation amount by the actual value of the cars before the accident (loss) and does not exceed the sum insured stated in the certificate of insurance.
Premium material cars','200')

insert into InsuranceType values('Good Insurance','Objects insurance:<br/><br/>

+ Insurance scope: Civil liability of vehicle owners to compensate the owners for the loss of cargo on cars according to of the Civil Code, in the case of vehicles: collision, flip, drop, falling, sinking, fire fire, fire, explosion, falling with other objects, and touching. <br/>
- The unforeseen disasters by nature: storms, floods, landslides, lightning, earthquakes, hail, tsunami. <br/>
- Expanding the scope of compensation in the case of goods cars owners <br/><br/>

Limit responsibility<br/>
+ The responsibility insurance (TRI) :<br/>
. From $1000/tons to $5000 VND/tons<br/>
. TRI Insurance / accident = TRI Insurance / tons x tonnage of car by Registered<br/>
+ Note: The insurance liability / tons is not responsibility the maximum level of 1 ton cargo<br/><br/>

Fees civil liability insurance of cars owners with goods<br/>

Insurance premiums (1 year, excluding VAT) = 0,55% x TRI Insurance / tons x tonnage of car by Registered','400')

insert into InsuranceType values('Accident Insurance','When unfortunate incidents insurance, not only damage caused to the cars involved, but also the means of control and the others in the car also suffered damage. To reduce the damage reduction part of the financial risks, implementing Car Insurance Accident insurance for drivers and passengers.<br/><br/>

Objects insurance<br/><br/>

Physical damage to the driver and the pillion. <br/>
+ Insurance scope: These people have an accident while in the car, on the car during transport cars are involved.<br/>
<br/>
Limit of responsibility<br/>
<br/>
+ Limit of the amount of responsibility insurance claim maximum Business insurance is to pay for the insurance benefits when insurance incident. <br/>
+ The amount insurance that the insured can freely choose: <br/>
- Amount of Vietnam Dong BH: 5,000,000 50,000,000 e e <br/>
- Amount in U.S. dollars BH: From $ 5,000 to $ 50,000 <br/>
- BH amount in U.S. dollars is greater than50,000 $ will be a separate agreement on Cars Insurance after reinsurance arrangements','350')

insert into VehicleType values('Toyota Camry 2.4',4)
insert into VehicleType values('Toyota Corola Artis',4)
insert into VehicleType values('Toyota Yaris',4)
insert into VehicleType values('Toyota Innova',7)
insert into VehicleType values('BMW X1',4)
insert into VehicleType values('BMW 320',7)
insert into VehicleType values('Hyundai Getz',4)
insert into VehicleType values('Hyundai Santafe',7)
insert into VehicleType values('Hyundai i10',4)
insert into VehicleType values('Honda Civic',4)
insert into VehicleType values('Honda CRV',7)

